import datetime
from applications.extensions import db

class Score(db.Model):
    __tablename__ = 'admin_psych_train_data2'
    id = db.Column(db.Integer, primary_key=True, comment='训练数据编号')
    user_id = db.Column(db.Integer, db.ForeignKey("administrator_police.id", ondelete='SET NULL'), comment='警员编号')
    type_id = db.Column(db.Integer, db.ForeignKey("admin_train_type.id", ondelete='SET NULL'), comment='训练编号')
    scene_name = db.Column(db.String(30), comment='情景名称')
    train_name = db.Column(db.String(30), comment=' 训练项名称')
    user_name = db.Column(db.String(20), comment='警员姓名')
    enable = db.Column(db.Integer, comment='是否开始训练')
    train_data = db.Column(db.String(30), comment='训练日期')
    start_time = db.Column(db.DateTime, comment='开始时间')
    end_time = db.Column(db.DateTime, comment='结束时间')
